CREATE TABLE LAF.CATEGORY
(
    CATE_ID NUMBER(*) PRIMARY KEY NOT NULL,
    CATE_NAME VARCHAR2(20) NOT NULL,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL
);
create sequence CATEGORY_SEQ start with 1;

INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '卡', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '钥匙', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '钱包', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, 'U盘', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '书籍', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '生活用品', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '电子设备', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '服饰衣帽', 1);
INSERT INTO LAF.CATEGORY (CATE_ID, CATE_NAME, DISPLAY) VALUES (CATEGORY_SEQ.nextval, '其他', 1);